IF OBJECT_ID('dbo.csp_rptMetric_ReportType') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.csp_rptMetric_ReportType
END
GO

CREATE PROCEDURE dbo.csp_rptMetric_ReportType
AS

SELECT
	ReportType
FROM
	(
		SELECT
			ReportType	= 'Week'
		,	SortOrder	= 1
		UNION
		SELECT
			ReportType	= 'Month'
		,	SortOrder	= 2
		UNION
		SELECT
			ReportType	= 'Quarter'
		,	SortOrder	= 3
	) AS x
ORDER BY
	SortOrder


GO
